SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwtSTecnicos
AS
SELECT     dbo.Tb_STecnicos.IDTecnico AS ID, dbo.Tb_STecnicos.ApellidoyNombre, dbo.vwrSAreasInformaticas.Descripcion AS Area, 
                      dbo.Tb_STecnicos.EMail
FROM         dbo.Tb_STecnicos INNER JOIN
                      dbo.vwrSAreasInformaticas ON dbo.Tb_STecnicos.IDAInformatica = dbo.vwrSAreasInformaticas.ID
GO
GRANT SELECT ON  [dbo].[vwtSTecnicos] TO [Informatica]
GRANT SELECT ON  [dbo].[vwtSTecnicos] TO [SoloVer]
GO
